# -*- coding:utf-8 -*-

from sqlalchemy import Column, ForeignKey, String, DateTime,Text
from config.database import BaseStock, Base


class StockBasic(Base, BaseStock):
    __tablename__ = "stock_basic"

    name = Column(String(20), comment='股票名称')

    symbol = Column(String(20), comment='股票代码')

    ts_code = Column(String(20), comment='TS代码')

    act_ent_type = Column(String(20), comment='实控人企业性质')

    act_name = Column(String(100), comment='实控人名称')

    area = Column(String(20), comment='地域')

    # cnspell = Column(String(20), comment='拼音缩写')

    # curr_type = Column(String(20), comment='交易货币')

    delist_date = Column(DateTime, comment='退市日期')

    # enname = Column(String(100), comment='英文全称')

    # exchange = Column(String(20), comment='交易所代码')

    fullname = Column(String(100), comment='股票全称')

    industry = Column(String(20), comment='所属行业')

    is_hs = Column(String(5), comment='是否沪深港通标的，N否 H沪股通 S深股通')

    list_date = Column(DateTime, comment='上市日期')

    # list_status = Column(String(20), comment='上市状态 L上市 D退市 P暂停上市')

    market = Column(String(20), comment='市场类型（主板/创业板/科创板/CDR）')

    other_info = Column(Text, comment='其他信息')
